package com.situ.water_Invoice.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.situ.water_Invoice.pojo.FPJP;
import com.situ.water_Invoice.pojo.FPSY;
import com.situ.water_system.pojo.SyEmp;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;
@Mapper
public interface fpsyMapper extends BaseMapper<FPSY> {
    //发票使用情况明细表查询
    @Select("select iv.InvoiceType,iv.InvoiceNo,iv.Used,iv.Invalid,py.PayNo,u.UserName,py.PayMoney,py.PayDate,e.EmpNmae from iv_invoice iv,py_pay py,us_user u,sy_emp e WHERE py.UserNo=u.UserNo and iv.InvoiceNo=py.Invoice and e.ID=py.EmpID")
    public List<FPSY> FPSYMX();

    @Select("select * from SY_Emp")
    List<SyEmp> FP_LYR();
}
